{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Expense Report","Administrator Instructions","Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":4,"defined_names":40,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Expense Report","index":0,"n_rows":120,"n_cols":11,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[]
["   EXPENSE REPORT "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"$ Per Mile Reimbursement Rate:"]
[null,null,null,null,null,0.45]
[]
[]
[null,null,"Personal Car Travel","Personal Car Travel","Calculated","Calculated"]
["Date","Description","From","To","Personal Car Mileage","Mileage Reimbursement","Other Transportation (Parking, Public Transit, etc.)","Air Fare","Lodging","Meals","Miscellanous"]
[null,null,null,null,{"$f":"IF(AND(C20<>\"\",D20<>\"\")=TRUE,RouteBing(0,C20,D20,0,1),\"\")","v":""},{"$f":"IF(ISNUMBER(E20)=TRUE,E20*Reimburse_val,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(C21<>\"\",D21<>\"\")=TRUE,RouteBing(0,C21,D21,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C22<>\"\",D22<>\"\")=TRUE,RouteBing(0,C22,D22,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C23<>\"\",D23<>\"\")=TRUE,RouteBing(0,C23,D23,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C24<>\"\",D24<>\"\")=TRUE,RouteBing(0,C24,D24,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C25<>\"\",D25<>\"\")=TRUE,RouteBing(0,C25,D25,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C26<>\"\",D26<>\"\")=TRUE,RouteBing(0,C26,D26,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C27<>\"\",D27<>\"\")=TRUE,RouteBing(0,C27,D27,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C28<>\"\",D28<>\"\")=TRUE,RouteBing(0,C28,D28,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C29<>\"\",D29<>\"\")=TRUE,RouteBing(0,C29,D29,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C30<>\"\",D30<>\"\")=TRUE,RouteBing(0,C30,D30,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C31<>\"\",D31<>\"\")=TRUE,RouteBing(0,C31,D31,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C32<>\"\",D32<>\"\")=TRUE,RouteBing(0,C32,D32,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C33<>\"\",D33<>\"\")=TRUE,RouteBing(0,C33,D33,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C34<>\"\",D34<>\"\")=TRUE,RouteBing(0,C34,D34,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C35<>\"\",D35<>\"\")=TRUE,RouteBing(0,C35,D35,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C36<>\"\",D36<>\"\")=TRUE,RouteBing(0,C36,D36,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C37<>\"\",D37<>\"\")=TRUE,RouteBing(0,C37,D37,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C38<>\"\",D38<>\"\")=TRUE,RouteBing(0,C38,D38,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C39<>\"\",D39<>\"\")=TRUE,RouteBing(0,C39,D39,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C40<>\"\",D40<>\"\")=TRUE,RouteBing(0,C40,D40,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C41<>\"\",D41<>\"\")=TRUE,RouteBing(0,C41,D41,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C42<>\"\",D42<>\"\")=TRUE,RouteBing(0,C42,D42,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C43<>\"\",D43<>\"\")=TRUE,RouteBing(0,C43,D43,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C44<>\"\",D44<>\"\")=TRUE,RouteBing(0,C44,D44,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C45<>\"\",D45<>\"\")=TRUE,RouteBing(0,C45,D45,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C46<>\"\",D46<>\"\")=TRUE,RouteBing(0,C46,D46,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C47<>\"\",D47<>\"\")=TRUE,RouteBing(0,C47,D47,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C48<>\"\",D48<>\"\")=TRUE,RouteBing(0,C48,D48,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C49<>\"\",D49<>\"\")=TRUE,RouteBing(0,C49,D49,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C50<>\"\",D50<>\"\")=TRUE,RouteBing(0,C50,D50,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C51<>\"\",D51<>\"\")=TRUE,RouteBing(0,C51,D51,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C52<>\"\",D52<>\"\")=TRUE,RouteBing(0,C52,D52,0,1),\"\")","v":""},{"$f":"IF(ISNUMBER(E52)=TRUE,E52*Reimburse_val,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(C53<>\"\",D53<>\"\")=TRUE,RouteBing(0,C53,D53,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C54<>\"\",D54<>\"\")=TRUE,RouteBing(0,C54,D54,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C55<>\"\",D55<>\"\")=TRUE,RouteBing(0,C55,D55,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C56<>\"\",D56<>\"\")=TRUE,RouteBing(0,C56,D56,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C57<>\"\",D57<>\"\")=TRUE,RouteBing(0,C57,D57,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C58<>\"\",D58<>\"\")=TRUE,RouteBing(0,C58,D58,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C59<>\"\",D59<>\"\")=TRUE,RouteBing(0,C59,D59,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C60<>\"\",D60<>\"\")=TRUE,RouteBing(0,C60,D60,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C61<>\"\",D61<>\"\")=TRUE,RouteBing(0,C61,D61,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C62<>\"\",D62<>\"\")=TRUE,RouteBing(0,C62,D62,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C63<>\"\",D63<>\"\")=TRUE,RouteBing(0,C63,D63,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C64<>\"\",D64<>\"\")=TRUE,RouteBing(0,C64,D64,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C65<>\"\",D65<>\"\")=TRUE,RouteBing(0,C65,D65,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C66<>\"\",D66<>\"\")=TRUE,RouteBing(0,C66,D66,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C67<>\"\",D67<>\"\")=TRUE,RouteBing(0,C67,D67,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C68<>\"\",D68<>\"\")=TRUE,RouteBing(0,C68,D68,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C69<>\"\",D69<>\"\")=TRUE,RouteBing(0,C69,D69,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C70<>\"\",D70<>\"\")=TRUE,RouteBing(0,C70,D70,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C71<>\"\",D71<>\"\")=TRUE,RouteBing(0,C71,D71,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C72<>\"\",D72<>\"\")=TRUE,RouteBing(0,C72,D72,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C73<>\"\",D73<>\"\")=TRUE,RouteBing(0,C73,D73,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C74<>\"\",D74<>\"\")=TRUE,RouteBing(0,C74,D74,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C75<>\"\",D75<>\"\")=TRUE,RouteBing(0,C75,D75,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C76<>\"\",D76<>\"\")=TRUE,RouteBing(0,C76,D76,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C77<>\"\",D77<>\"\")=TRUE,RouteBing(0,C77,D77,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C78<>\"\",D78<>\"\")=TRUE,RouteBing(0,C78,D78,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C79<>\"\",D79<>\"\")=TRUE,RouteBing(0,C79,D79,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C80<>\"\",D80<>\"\")=TRUE,RouteBing(0,C80,D80,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C81<>\"\",D81<>\"\")=TRUE,RouteBing(0,C81,D81,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C82<>\"\",D82<>\"\")=TRUE,RouteBing(0,C82,D82,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C83<>\"\",D83<>\"\")=TRUE,RouteBing(0,C83,D83,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C84<>\"\",D84<>\"\")=TRUE,RouteBing(0,C84,D84,0,1),\"\")","v":""},{"$f":"IF(ISNUMBER(E84)=TRUE,E84*Reimburse_val,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(C85<>\"\",D85<>\"\")=TRUE,RouteBing(0,C85,D85,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C86<>\"\",D86<>\"\")=TRUE,RouteBing(0,C86,D86,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C87<>\"\",D87<>\"\")=TRUE,RouteBing(0,C87,D87,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C88<>\"\",D88<>\"\")=TRUE,RouteBing(0,C88,D88,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C89<>\"\",D89<>\"\")=TRUE,RouteBing(0,C89,D89,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C90<>\"\",D90<>\"\")=TRUE,RouteBing(0,C90,D90,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C91<>\"\",D91<>\"\")=TRUE,RouteBing(0,C91,D91,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C92<>\"\",D92<>\"\")=TRUE,RouteBing(0,C92,D92,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C93<>\"\",D93<>\"\")=TRUE,RouteBing(0,C93,D93,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C94<>\"\",D94<>\"\")=TRUE,RouteBing(0,C94,D94,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C95<>\"\",D95<>\"\")=TRUE,RouteBing(0,C95,D95,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C96<>\"\",D96<>\"\")=TRUE,RouteBing(0,C96,D96,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C97<>\"\",D97<>\"\")=TRUE,RouteBing(0,C97,D97,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C98<>\"\",D98<>\"\")=TRUE,RouteBing(0,C98,D98,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C99<>\"\",D99<>\"\")=TRUE,RouteBing(0,C99,D99,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C100<>\"\",D100<>\"\")=TRUE,RouteBing(0,C100,D100,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C101<>\"\",D101<>\"\")=TRUE,RouteBing(0,C101,D101,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C102<>\"\",D102<>\"\")=TRUE,RouteBing(0,C102,D102,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C103<>\"\",D103<>\"\")=TRUE,RouteBing(0,C103,D103,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C104<>\"\",D104<>\"\")=TRUE,RouteBing(0,C104,D104,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C105<>\"\",D105<>\"\")=TRUE,RouteBing(0,C105,D105,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C106<>\"\",D106<>\"\")=TRUE,RouteBing(0,C106,D106,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C107<>\"\",D107<>\"\")=TRUE,RouteBing(0,C107,D107,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C108<>\"\",D108<>\"\")=TRUE,RouteBing(0,C108,D108,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C109<>\"\",D109<>\"\")=TRUE,RouteBing(0,C109,D109,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C110<>\"\",D110<>\"\")=TRUE,RouteBing(0,C110,D110,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C111<>\"\",D111<>\"\")=TRUE,RouteBing(0,C111,D111,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C112<>\"\",D112<>\"\")=TRUE,RouteBing(0,C112,D112,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C113<>\"\",D113<>\"\")=TRUE,RouteBing(0,C113,D113,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C114<>\"\",D114<>\"\")=TRUE,RouteBing(0,C114,D114,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C115<>\"\",D115<>\"\")=TRUE,RouteBing(0,C115,D115,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C116<>\"\",D116<>\"\")=TRUE,RouteBing(0,C116,D116,0,1),\"\")","v":""},{"$f":"IF(ISNUMBER(E116)=TRUE,E116*Reimburse_val,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(C117<>\"\",D117<>\"\")=TRUE,RouteBing(0,C117,D117,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C118<>\"\",D118<>\"\")=TRUE,RouteBing(0,C118,D118,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C119<>\"\",D119<>\"\")=TRUE,RouteBing(0,C119,D119,0,1),\"\")","v":""},""]
[null,null,null,null,{"$f":"IF(AND(C120<>\"\",D120<>\"\")=TRUE,RouteBing(0,C120,D120,0,1),\"\")","v":""},""]

{"sheet":"Administrator Instructions","index":1,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CDX Technologies Support     "]
[null,null,"Expense Report Template",null,null,null,null,null,null,null,null,null,null,null,null,"(973) 895-5542     "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"support@CDXTech.com      "]
[]
[null,null,"Note:  This template works with Microsoft Excel 2010 and higher, and Excel for Mac 2011 and higher. It will not work on "]
[null,null,"spreadsheets such as \"Numbers\" without VBA.   If you need to analyze more data or require additional customization,"]
[null,null,"please email customsolutions@cdxtech.com or call (877) 239-8321."]
[]
[null,null,"This template will automatically calculate personal car driving mileage and reimbursement as part of an expense report. "]
[null,null,"The driving distance formulas are built in and no additional software is required.   There are no restrictions on the number of "]
[null,null,"users that can access the template."]
[]
[null,null,"Use the \"Save As\" option to save this template under a new name.  This ensures the original template will remain unchanged."]
[]
[null,null,"CDXGeoData API and Bing Maps keys are required to calculate driving distance in this template.   These keys are entered"]
[null,null,"when the template opens.  (These can also be managed from your account on CDXTech.com.)   You can also specify a proxy  "]
[null,null,"connection when the template opens."]
[]
[]
[]
[]
[]
[null,null,"Once you have entered the CDXGeoData API key in the template, save the template.  This also saves the key so the template can"]
[null,null,"be distributed to and used by others in your organization.  The Settings dialog will not appear again once the key is entered."]
[]
[null,null,"Press the tab at the bottom of the screen to go to the Expense Report worksheet.  Expense information can be entered here, including"]
[null,null,"the \"From\" and \"To\" locations for personal car travel.  The template equations will automatically calculate the driving distance "]
[null,null,"between these locations, and calculate the mileage reimbursement based on the reimbursement rate.  Make sure to enter"]
[null,null,"the reimbursement rate (in $/mile) in the highlighted cell."]
[]
[null,null,"The RouteBing formula embedded in the worksheet calculates driving distance.   The parameters entered in the formula will match "]
[null,null,"the documentation for the GeoRouteBing formula of the Geodata Excel Add-in.  "]
[]
[null,null,"You can modify the Expense Report worksheet to meet your organization's requirements by inserting text, rows, and columns.  "]
[null,null,"However, you must ensure that the template equations continue to reference the correct cells that contain the \"From\" and \"To\""]
[null,null,"locations, driving mileage, and reimbursement rate.  You may wish to use Excel's cell locking feature to prevent these equations"]
[null,null,"from being accidentally changed after the template is distributed."]
[]
[]
[null,null,"Copyright © 2019 Hughes Financial Services, Inc."]
[null,null,"Version 1.1"]

{"sheet":"Data","index":2,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Proxy_Set",1,null,null,"API Key"]
["Proxy Username"]
["Proxy Password"]
["Use Autoproxy",1]
["Proxy_Server"]
["All_set",0]